package com.itheima.reggie.controller;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.itheima.reggie.common.R;
import com.itheima.reggie.entity.Category;
import com.itheima.reggie.service.CategoryService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/category")
@Slf4j
public class CategoryController {

    @Autowired
    private CategoryService categoryService;

    //新增分类
    @PostMapping
    public R<String> save(@RequestBody Category category){
        log.info("category:{}",category);
        categoryService.save(category);
        return R.success("新增分类成功");

    }
    //分类进行分页查看
    @GetMapping("/page")
    public R<Page> page(int page,int pageSize){
        //分页构造器,携带2个分页参数
        Page<Category> pageInfo=new Page<>(page,pageSize);
        //条件构造器
        //#查询第2页10条数据，以sort列进行排序
        //SELECT *  FROM category   ORDER BY sort LIMIT  0 , 10
        LambdaQueryWrapper<Category> lqw=new LambdaQueryWrapper<>();
        //添加排序条件
        lqw.orderByAsc(Category::getSort);

        //分页查询
        categoryService.page(pageInfo,lqw);
        //返回R对象,R对象携带Page(total,records)
        return R.success(pageInfo);
    }

    //根据ID删除分类信息
    @DeleteMapping
    public R<String> delete(Long id){
        log.info("删除分类:{},id为:",id);
        //categoryService.removeById(id);
        categoryService.removeMyId(id);
        return R.success("分类信息删除成功");
    }

    //根据ID修改分类信息
    @PutMapping
    public R<String> update(@RequestBody Category category){
        log.info("修改分类信息：{}",category);
        categoryService.updateById(category);
        return R.success("修改分类信息成功");
    }

    //根据条件查询分类数据
    //GET http://localhost:8080/category/list?type=1
    @GetMapping("/list")
    public R<List<Category>> list(Category category){
        //SELECT * FROM category WHERE TYPE=1 ORDER BY sort desc, update_time asc
        //条件构造器
        LambdaQueryWrapper<Category> lqw=new LambdaQueryWrapper<>();
        //添加根据type查询条件 WHERE TYPE=1
        lqw.eq(category.getType()!=null,Category::getType,category.getType());
        //添加排序条件
        lqw.orderByAsc(Category::getSort).orderByDesc(Category::getUpdateTime);
        //执行查询返回结果
        List<Category> list = categoryService.list(lqw);
        return R.success(list);
    }

}
